Mode (fld), Mode (fld, condFld), Mode (fld, condFld, cond)

Basic and Crystal syntax.

Arguments
Returns

Fractional Number

Action

Identifies the most frequently occurring value.

For example:

Examples

The following examples are applicable to both Basic and Crystal syntax:

Mode({Customer.CUSTOMER NAME})

Returns the mode (the most frequently occurring value) for the Customer Name field.

Mode({Customer.CUSTOMER NAME}, {Customer.REGION})

Groups values in the Customer Name field by region, and then returns the mode for the Customer Name field, per region.

Mode({Customer.CUSTOMER NAME}, {Customer.REGION}, "monthly")

Groups values in the Customer Name field by region, then returns the mode of the Customer Name field for each region, per month.

Comments

Mode works like NthMost Frequent when N = 1.

Note:    Using this function in a formula forces the formula to be evaluated at print time.

For more information on evaluation time considerations, see Evaluation Time functions.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com